/*
 * Copyright (c) 2002-2003 by OpenSymphony
 * All rights reserved.
 */
package com.opensymphony.user.provider.hibernate3.ahxu.dao;

import com.opensymphony.user.provider.hibernate3.ahxu.entity.HibernateGroup;
import com.opensymphony.user.provider.hibernate3.ahxu.entity.HibernateUser;


/**
 * @author <a href="mailto:matthew@linjafoo.com">Matthew E. Porter</a>
 */
public class HibernateQueries {
    //~ Static fields/initializers /////////////////////////////////////////////

    public static final String USER_BY_USERNAME = "select distinct hibuser from HibernateUserImpl hibuser where hibuser.name = ? ";
    public static final String USER_BY_USERNAME_AND_GROUPNAME = "select distinct hibuser from HibernateUserImpl hibuser, hibuser.groups.elements  hibgroup where hibuser.name = ? and hibgroup.name = ?";
    public static final String ALL_USERS = "from HibernateUserImpl hibusers";
    public static final String GROUP_BY_GROUPNAME = "select distinct hibgroup from HibernateGroupImpl hibgroup where hibgroup.name = ? ";
    public static final String ALL_GROUPS = "from HibernateGroupImpl hibgroups";
}
